-- ----------------------------
-- 该脚本用于删除自动生成的用户权限管理数据。在搭建初始环境的时候，不要执行该脚本。
-- 再次重新生成项目的时候，如果您在生成器中新增了用户权限相关的数据，而之前已经搭建好的数据库中，也存在了
-- 您自己手动插入的权限数据时，可以通过执行该脚本，将现有数据库表中，生成器生成的权限数据删除，删除之后，可以再执行新生成的数据库脚本数据。
-- 请仅在下面的数据库链接中执行该脚本。
-- 主数据源 [10.10.1.21:3306/copy]
-- ----------------------------

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 以下记录用于移动端路由表单九宫格数据，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
BEGIN;
DELETE FROM `zz_mobile_entry` WHERE entry_id = 1900067534233669632;
DELETE FROM `zz_mobile_entry` WHERE entry_id = 1900067634267820032;
DELETE FROM `zz_mobile_entry` WHERE entry_id = 1900417517990449152;
COMMIT;

-- ----------------------------
-- 全部菜单数据
-- ----------------------------
BEGIN;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806717591553;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980160;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721377;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721378;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721379;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721380;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721381;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980161;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721383;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721384;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721385;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721386;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721387;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721388;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980162;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721390;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721391;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721392;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721393;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721394;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721395;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721396;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721397;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721398;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980163;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721400;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721401;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721402;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721403;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721404;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721405;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721406;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721407;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721408;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980164;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721410;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721411;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721412;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721413;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819434721414;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980165;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915585;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915586;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915587;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915588;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980168;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915592;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915593;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915594;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915595;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915596;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980169;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915598;
DELETE FROM `sys_menu` WHERE menu_id = 1897896806725980170;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915600;
DELETE FROM `sys_menu` WHERE menu_id = 1897896819438915601;
DELETE FROM `sys_menu` WHERE menu_id = 1899010956055285760;
DELETE FROM `sys_menu` WHERE menu_id = 1899011152201912320;
DELETE FROM `sys_menu` WHERE menu_id = 1899012107475619840;
DELETE FROM `sys_menu` WHERE menu_id = 1899012247238217728;
DELETE FROM `sys_menu` WHERE menu_id = 1899012743978029056;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882269;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882270;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882271;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882272;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882273;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882274;
DELETE FROM `sys_menu` WHERE menu_id = 1899012853378060288;
DELETE FROM `sys_menu` WHERE menu_id = 1899012928338661376;
DELETE FROM `sys_menu` WHERE menu_id = 1899013066540978176;
DELETE FROM `sys_menu` WHERE menu_id = 1899014185522565120;
DELETE FROM `sys_menu` WHERE menu_id = 1899014383447576576;
DELETE FROM `sys_menu` WHERE menu_id = 1899014509402525696;
DELETE FROM `sys_menu` WHERE menu_id = 1899014862906855424;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882282;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882283;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882284;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882285;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882286;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882287;
DELETE FROM `sys_menu` WHERE menu_id = 1899015129555537920;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882291;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882292;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882293;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882294;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882295;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882296;
DELETE FROM `sys_menu` WHERE menu_id = 1899017370261786624;
DELETE FROM `sys_menu` WHERE menu_id = 1899734657906249813;
DELETE FROM `sys_menu` WHERE menu_id = 1899734657906249814;
DELETE FROM `sys_menu` WHERE menu_id = 1899734657906249815;
DELETE FROM `sys_menu` WHERE menu_id = 1899734657906249816;
DELETE FROM `sys_menu` WHERE menu_id = 1899734657906249817;
DELETE FROM `sys_menu` WHERE menu_id = 1899734657906249818;
DELETE FROM `sys_menu` WHERE menu_id = 1899017971754340352;
DELETE FROM `sys_menu` WHERE menu_id = 1899993555347181812;
DELETE FROM `sys_menu` WHERE menu_id = 1899993555347181813;
DELETE FROM `sys_menu` WHERE menu_id = 1899993555347181814;
DELETE FROM `sys_menu` WHERE menu_id = 1899993555347181815;
DELETE FROM `sys_menu` WHERE menu_id = 1899993555347181816;
DELETE FROM `sys_menu` WHERE menu_id = 1899993555347181817;
DELETE FROM `sys_menu` WHERE menu_id = 1899018236830158848;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882313;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882314;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882315;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882316;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882317;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882318;
DELETE FROM `sys_menu` WHERE menu_id = 1899018452270583808;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882320;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882321;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882322;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882323;
DELETE FROM `sys_menu` WHERE menu_id = 1899018885894508544;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882325;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882326;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882327;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882328;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882329;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882330;
DELETE FROM `sys_menu` WHERE menu_id = 1899018994510204928;
DELETE FROM `sys_menu` WHERE menu_id = 1900418577010266399;
DELETE FROM `sys_menu` WHERE menu_id = 1900418577010266400;
DELETE FROM `sys_menu` WHERE menu_id = 1900418577010266401;
DELETE FROM `sys_menu` WHERE menu_id = 1900418577010266402;
DELETE FROM `sys_menu` WHERE menu_id = 1900418577010266403;
DELETE FROM `sys_menu` WHERE menu_id = 1900418577010266404;
DELETE FROM `sys_menu` WHERE menu_id = 1899019300644065280;
DELETE FROM `sys_menu` WHERE menu_id = 1899019482676858880;
DELETE FROM `sys_menu` WHERE menu_id = 1899019679142252544;
DELETE FROM `sys_menu` WHERE menu_id = 1899019908230942720;
DELETE FROM `sys_menu` WHERE menu_id = 1899019978548449280;
DELETE FROM `sys_menu` WHERE menu_id = 1899020155732627456;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882344;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882345;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882346;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882347;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882348;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882349;
DELETE FROM `sys_menu` WHERE menu_id = 1899020486520606720;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882351;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882352;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882353;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882354;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882355;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882356;
DELETE FROM `sys_menu` WHERE menu_id = 1899020609979944960;
DELETE FROM `sys_menu` WHERE menu_id = 1899020686945423360;
DELETE FROM `sys_menu` WHERE menu_id = 1899020804281077760;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882360;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882361;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882362;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882363;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882364;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882365;
DELETE FROM `sys_menu` WHERE menu_id = 1899020889383505920;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882367;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882368;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882369;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882370;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882371;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882372;
DELETE FROM `sys_menu` WHERE menu_id = 1899021193390854144;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882374;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882375;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882376;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882377;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882378;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882379;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882380;
DELETE FROM `sys_menu` WHERE menu_id = 1899021298466557952;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882382;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882383;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882384;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882385;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882386;
DELETE FROM `sys_menu` WHERE menu_id = 1899645401384882387;
DELETE FROM `sys_menu` WHERE menu_id = 1899021374849028096;
DELETE FROM `sys_menu` WHERE menu_id = 1899021550665863168;

-- ----------------------------
-- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `sys_menu` WHERE menu_id = 1687821642446671872;
DELETE FROM `sys_menu` WHERE menu_id = 1688105082400280576;
DELETE FROM `sys_menu` WHERE menu_id = 1687821728979357696;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `sys_menu` WHERE menu_id = 1634009076981567488;
DELETE FROM `sys_menu` WHERE menu_id = 1392786950682841088;
DELETE FROM `sys_menu` WHERE menu_id = 1392786549942259712;
DELETE FROM `sys_menu` WHERE menu_id = 1392786476428693504;

-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `sys_menu` WHERE menu_id = 1534897180643430400;
DELETE FROM `sys_menu` WHERE menu_id = 1517063268609298432;
DELETE FROM `sys_menu` WHERE menu_id = 1516291375656603648;
DELETE FROM `sys_menu` WHERE menu_id = 1515858207237476352;
DELETE FROM `sys_menu` WHERE menu_id = 1515858116057501696;
DELETE FROM `sys_menu` WHERE menu_id = 1515857992501694464;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM `sys_menu` WHERE menu_id = 1418057714138877952;
DELETE FROM `sys_menu` WHERE menu_id = 1418059005175009280;
DELETE FROM `sys_menu` WHERE menu_id = 1418057835631087616;
DELETE FROM `sys_menu` WHERE menu_id = 1418057835631087617;
DELETE FROM `sys_menu` WHERE menu_id = 1418058289182150656;
DELETE FROM `sys_menu` WHERE menu_id = 1418058744037642240;
DELETE FROM `sys_menu` WHERE menu_id = 1418059167532322816;
DELETE FROM `sys_menu` WHERE menu_id = 1418059283920064512;
DELETE FROM `sys_menu` WHERE menu_id = 1423161217970606080;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
